Where did the data come from?

Brief History of Public Education in TN

TN State Expenditure by Type 2013

TN State Expenditure by Type 2013

Top 2017 High School Rankings Tennesse 2017 High School Ranking

Correlation Matrix of Averaged IRS Data

Correlation Matrix of CORE Education Data

Per Pupil Expenditure

Percentage of Black, Hispanic, and Native American

Graduation Rate

Dropout Rate

Model Prediction of Core Scores Effect on ACT Score


Call:
lm(formula = ACT_Composite ~ avg_Eng + avg_Math + avg_Sci + Dropout + 
    Pct_Suspended, data = merged_irs)

Coefficients:
  (Intercept)        avg_Eng       avg_Math        avg_Sci        Dropout  
    11.114965       0.104072       0.010566       0.020567       0.039315  
Pct_Suspended  
     0.003943  


Call:
lm(formula = ACT_Composite ~ avg_Eng + avg_Math + avg_Sci, data = merged_irs)

Residuals:
    Min      1Q  Median      3Q     Max 
-2.2815 -0.5650 -0.1270  0.4809  1.9070 

Coefficients:
             Estimate Std. Error t value Pr(>|t|)    
(Intercept) 12.114030   0.099123 122.212  < 2e-16 ***
avg_Eng      0.095159   0.004602  20.676  < 2e-16 ***
avg_Math     0.010742   0.001736   6.190 6.91e-10 ***
avg_Sci      0.016612   0.003327   4.994 6.29e-07 ***
---
Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1

Residual standard error: 0.7008 on 2801 degrees of freedom
Multiple R-squared:  0.6806,    Adjusted R-squared:  0.6803 
F-statistic:  1990 on 3 and 2801 DF,  p-value: < 2.2e-16
       1 
21.91506 
       1 
23.14019 
       1 
19.35738 

\[ACT_Composite = 12.114030 + 0.095159 * avg_Eng + 0.010742 * avg_Math + 0.016612 * avg_Sci\]